﻿using System;

namespace edowork.com.Model
{
    #region provinceInfo

    [Serializable]
    public class provinceInfo
    {
        #region Private fields

        protected string _provinceid = String.Empty;
        protected string _provincename = String.Empty;
        protected string _regionid = String.Empty;
        protected string _sysdate = String.Empty;

        #endregion

        public provinceInfo() { }

        #region Public Properties

        public string Provinceid
        {
            get { return _provinceid; }
            set { _provinceid = value; }
        }

        public string Provincename
        {
            get { return _provincename; }
            set { _provincename = value; }
        }

        public string Regionid
        {
            get { return _regionid; }
            set { _regionid = value; }
        }

        public string Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into province(Provinceid,Provincename,Regionid,Sysdate) values('{0}','{1}','{2}','{3}')";
        }

        #endregion

    }

    #endregion
}

